package com.woniuxy.educationplatform.mapper;

import com.woniuxy.educationplatform.bean.OrderAddress;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface OrderAddressMapper {
    /**
     * 查询属于学员的所有地址
     * @param id 学员id
     * @return list
     */
    @Select("select accept,telephone,province,city,area,addr,postcode from orderaddress where fk_student_id = #{id} and status != 2")
    List<OrderAddress> findAddressesByStudentId(Long id);
}
